You want to ALTER , as follows: ALTER TABLE [dbo].[Case] ADD CaseName NVARCHAR(50). Better yet, you can check for the existance of the ... ... <看更多>

... <看更多>

Find if the column exists using the SQL below: SELECT column_name FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_SCHEMA =[Database Name] AND TABLE_NAME =[Table ... ... <看更多>